﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace PMS
{
    public class PagerQueryParam
    {
        /// <summary>
        /// 表名称
        /// </summary>
        public string TableName { get; set; }
        /// <summary>
        /// 主键字段
        /// </summary>
        public string PrimaryKey { get; set; }
        /// <summary>
        /// 排序字段
        /// </summary>
        public string OrderField { get; set; }
        /// <summary>
        /// 排序类型 1:升序 0:降序 默认0
        /// </summary>
        public int OrderType
        { get; set; }
        /// <summary>
        /// 显示字段 中间用,隔开，如果是关联表字段表名.[字段名]
        /// </summary>
        public string ShowFields
        { get; set; }
        /// <summary>
        /// 页码　默认等于1
        /// </summary>
        public int PageIndex
        { get; set; }
        /// <summary>
        /// 页大小　默认int.MaxValue
        /// </summary>
        public int PageSize
        { get; set; }
        /// <summary>
        /// 记录总数 初始值为0,当PageIndex!=1,请转入此参数 已提高存储过程的执行速度
        /// </summary>
        public int TotalCount
        { get; set; }
        /// <summary>
        /// 查询条件，不带Where,多表查询时，请在字段前加上表别名
        /// </summary>
        public string StrWhere
        { get; set; }
    }
}